// ******************************************************************
// * Copyright(c)  Dextrys P&G Team
// * Description   : Schema_INV_STORAGE
// * CreateDate    : 2012/11/1 13:52:21
// * Creater       : InvStorageTable
// * LastChangeDate: 2012/11/1 13:52:21
// * LastChanger   : 2012/11/1 13:52:21
// * Version Info  : 1.0 For LKBOOK
// ******************************************************************

using System;
using System.Collections.Generic;
using System.Text;
using Suzsoft.Smart.EntityCore;

namespace ESOL.Common.Schema
{
    [Serializable]
    public partial class InvStorageTable : TableInfo
    {
        public const string C_TableName = "INV_STORAGE";

        public const string C_PRODUCT_ID = "PRODUCT_ID";
        public const string C_LOCATION_ID = "LOCATION_ID";
        public const string C_CURRENT_QTY = "CURRENT_QTY";
        public const string C_FIXED_QTY = "FIXED_QTY";
        public const string C_LAST_RELATED_ORDER = "LAST_RELATED_ORDER";
        public const string C_LAST_UPDATE_DATE = "LAST_UPDATE_DATE";
        public const string C_LAST_MODIFIED_BY = "LAST_MODIFIED_BY";

        public InvStorageTable()
        {
            _tableName = "INV_STORAGE";
        }

        protected static InvStorageTable _current;
        public static InvStorageTable Current
        {
            get
            {
                if (_current == null)
                {
                    Initial();
                }
                return _current;
            }
        }

        private static void Initial()
        {
            _current = new InvStorageTable();

            _current.Add(C_PRODUCT_ID, new ColumnInfo(C_PRODUCT_ID, "ProductId", true, typeof(string)));
            _current.Add(C_LOCATION_ID, new ColumnInfo(C_LOCATION_ID, "LocationId", true, typeof(string)));
            _current.Add(C_CURRENT_QTY, new ColumnInfo(C_CURRENT_QTY, "CurrentQty", false, typeof(decimal)));
            _current.Add(C_FIXED_QTY, new ColumnInfo(C_FIXED_QTY, "FixedQty", false, typeof(decimal)));
            _current.Add(C_LAST_RELATED_ORDER, new ColumnInfo(C_LAST_RELATED_ORDER, "LastRelatedOrder", false, typeof(string)));
            _current.Add(C_LAST_UPDATE_DATE, new ColumnInfo(C_LAST_UPDATE_DATE, "LastUpdateDate", false, typeof(DateTime)));
            _current.Add(C_LAST_MODIFIED_BY, new ColumnInfo(C_LAST_MODIFIED_BY, "LastModifiedBy", false, typeof(string)));

        }

        public ColumnInfo PRODUCT_ID
        {
            get { return this[C_PRODUCT_ID]; }
        }

        public ColumnInfo LOCATION_ID
        {
            get { return this[C_LOCATION_ID]; }
        }

        public ColumnInfo CURRENT_QTY
        {
            get { return this[C_CURRENT_QTY]; }
        }

        public ColumnInfo FIXED_QTY
        {
            get { return this[C_FIXED_QTY]; }
        }

        public ColumnInfo LAST_RELATED_ORDER
        {
            get { return this[C_LAST_RELATED_ORDER]; }
        }

        public ColumnInfo LAST_UPDATE_DATE
        {
            get { return this[C_LAST_UPDATE_DATE]; }
        }

        public ColumnInfo LAST_MODIFIED_BY
        {
            get { return this[C_LAST_MODIFIED_BY]; }
        }



    }
}

